StudentRt4Calculation 
EntityType  Independent 
Logical Entity Name  StudentRt4Calculation 
Default Table Name  SaReturnOfT4 
Logical Only  NO 
Definition 
 
Note 
 

StudentRt4Calculation Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentRt4CalculationId(PK)    INTEGER  NO 
 
StudentId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
DropDate    DATETIME  NO 
 
CalculationDate    DATETIME  YES 
 
PeriodUsed    CHAR(1)  YES 
 
PeriodBeginDate    DATETIME  YES 
 
PeriodEndDate    DATETIME  YES 
 
AidDisbursed    MONEY(19, 4)  YES 
 
AidCouldHaveBeenDisbursed    MONEY(19, 4)  YES 
 
CompletedDays    INTEGER  YES 
 
TotalDays    INTEGER  YES 
 
CompletedHours    NUMERIC(9, 2)  YES 
 
TotalHours    NUMERIC(9, 2)  YES 
 
ScheduledHours    NUMERIC(9, 2)  YES 
 
PercentageTitleIvAidEarned    NUMERIC(5, 2)  YES 
 
AmountTitleIvAidEarned    MONEY(19, 4)  YES 
 
InstitutionalCharges    MONEY(19, 4)  YES 
 
AidToReturn    MONEY(19, 4)  YES 
 
AidToReturnSchool    MONEY(19, 4)  YES 
 
AidToReturnStudent    MONEY(19, 4)  YES 
 
PWDAmount    MONEY(19, 4)  YES 
 
PWDOutstandingCharge    MONEY(19, 4)  YES 
 
PWDTuitionCredit    MONEY(19, 4)  YES 
 
PWDOtherCredit    MONEY(19, 4)  YES 
 
PWDPriorYearCredit    MONEY(19, 4)  YES 
 
PWDCreditAuthorizationDate    DATETIME  YES 
 
PWDNotificationDate    DATETIME  YES 
 
PWDOfferNotificationDate    DATETIME  YES 
 
PwOfferNotificationResponseDate    DATETIME  YES 
 
PWDAmountOffered    MONEY(19, 4)  YES 
 
PWDAmountAccepted    MONEY(19, 4)  YES 
 
PWDAmountSentDate    DATETIME  YES 
 
TermId(FK)    INTEGER  YES 
 
StudentAcademicYearId(FK)    INTEGER  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
ProgramType    CHAR(1)  NO 
 
IsAttendanceUsed    BIT  NO 
 
IsAidToReturnStudentIncluded    BIT  NO 
 
ProtectedTivAmount    MONEY(19, 4)  YES 
 
InitialTivAmountOwedByStudent    MONEY(19, 4)  YES 
 
RefundCalculationStatusId(FK)    INTEGER  YES 
 
RefundCalculationActionId(FK)    INTEGER  YES 
 
IsAutoApproved    BIT  NO 
 
ApprovedDate    DATETIME  YES 
 
EligibleChargeAccountBalance    MONEY(19, 4)  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 
StudentAcademicYearLoanPaymentPeriodId(FK)    INTEGER  YES 
 
StudentAcademicYearLoanPaymentPeriodId(FK)    INTEGER  YES 
 
StudentAcademicYearPaymentPeriodId(FK)    INTEGER  YES 
 

StudentRt4Calculation Keys 
Key Name  Key Type  Keys 
SaReturnOfT4_SaReturnOfT4ID_U_C_IDX  PrimaryKey  StudentRt4CalculationId 
SaReturnofT4_FaStudentLPPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearLoanPaymentPeriodId 
SaReturnofT4_FaStudentAyPaymentPeriodId_N_N_IDX  Inversion Entry  StudentAcademicYearPaymentPeriodId 
SaReturnOfT4_AdEnrollID_DropDate_N_N_IDX  Inversion Entry  DropDate 

StudentRt4Calculation Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentAcademicYearLoanPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearLoanPaymentPeriodId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
RefundCalculationAction  Non-Identifying  Zero or One to Zero or More        RefundCalculationActionId  NO 
RefundCalculationStatus  Non-Identifying  Zero or One to Zero or More        RefundCalculationStatusId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentAcademicYear  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearId  NO 
StudentAcademicYearLoanPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearLoanPaymentPeriodId  NO 
StudentAcademicYearPaymentPeriod  Non-Identifying  Zero or One to Zero or More        StudentAcademicYearPaymentPeriodId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
SaRefundCalculationWorkflowAudit  Non-Identifying  One To Zero or More          NO 
SaReturnOfT4Assignment  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationPostWithdrawalDisbursement  Non-Identifying  One To Zero or More          NO 
SaReturnOfT4StudentGroup_Faa  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
StudentRefundCalculation  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationInstCharge  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationPostWithdrawalDisbursement  Non-Identifying  One To Zero or More          NO 
StudentRt4CalculationStudentAward  Non-Identifying  One To Zero or More          NO 

StudentRt4Calculation Check Constraints 
Check Constraint Name  CheckConstraint